How to: Move a worksheet to a different workbook.
Solution:
Select the worksheet to move. Select 'Move or Copy Sheet...' from the 'Edit' menu. Specify the name of the destination workbook and the location of the worksheet within the destination workbook.
1) Select the worksheet to be moved.
2) Select the 'Edit' menu and select 'Move or Copy Sheet...'. (The Move or Copy dialog box appears.)
NOTE: To move a worksheet to another workbook, that workbook must be currently open.
3) Select the name of the workbook to which the worksheet should be moved from the 'To Book' drop-down list.
4) Select the location where the worksheet should be placed in the destination workbook from the 'Before Sheet' list box.
Moving a worksheet
5) Click 'OK'.
